[ROOT] dt DimEmployee < WHERE ParentEmployeeId EQ '46' >
5 items
| DimEmployeeId | BaseRate | BirthDate | Department | EmailAddress | EmergencyContactName | EmergencyContactPhone | EmployeeNationalIDAlternateKey | EndDate | FirstName | Gender | HireDate | LastName | LoginID | MaritalStatus | MiddleName | ParentEmployeeId | PayFrequency | Phone | Photo | SickLeaveHours | StartDate | Status | Title | VacationHours |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 98 | 16 | 1992-10-09 | Production Control | william0@adventure-works.com | William Vong | 148-555-0145 | 621209647 | 2022-08-03 | William | M | 2019-12-11 | Vong | adventure-works\william0 | M | S | 46 | 2 | 148-555-0145 | | 42 | 2019-12-11 | Scheduling Assistant | 45 | |
| 99 | 16 | 1992-10-09 | Production Control | william0@adventure-works.com | William Vong | 148-555-0145 | 621209647 | William | M | 2019-12-11 | Vong | adventure-works\william0 | M | S | 46 | 2 | 148-555-0145 | | 42 | 2022-08-04 | Current | Scheduling Assistant | 45 | |
| 135 | 16 | 1998-11-24 | Production Control | sairaj0@adventure-works.com | Sairaj Uddin | 500-555-0159 | 981495526 | Sairaj | M | 2019-12-30 | Uddin | adventure-works\sairaj0 | M | L | 46 | 2 | 500-555-0159 | | 43 | 2019-12-30 | Current | Scheduling Assistant | 46 | |
| 174 | 16 | 1995-03-02 | Production Control | alan0@adventure-works.com | Alan Brewer | 438-555-0172 | 470689086 | Alan | M | 2020-01-17 | Brewer | adventure-works\alan0 | M | J | 46 | 2 | 438-555-0172 | | 43 | 2020-01-17 | Current | Scheduling Assistant | 47 | |
| 210 | 16 | 1995-07-15 | Production Control | brian1@adventure-works.com | Brian LaMee | 313-555-0196 | 368691270 | Brian | M | 2020-02-04 | LaMee | adventure-works\brian1 | M | P | 46 | 2 | 313-555-0196 | | 44 | 2020-02-04 | Current | Scheduling Assistant | 48 |
Generated 2025-06-02 13:59:43.210 UTC